class CreateExamSchedules < ActiveRecord::Migration
  def self.up
    create_table :exam_schedules do |t|
      t.integer :syllabus_opening_id
      t.integer :course_id
      t.integer :exam_id
      t.datetime :start
      t.datetime :end
      t.integer :score_type
      t.float :score_a
      t.float :score_b
      t.float :score_c
      t.float :score_d
      t.float :z_score_a
      t.float :z_score_b
      t.float :z_score_c
      t.float :z_score_d
      t.boolean :grading_finish, :default => false
      t.string :created_by
      t.string :updated_by
      t.timestamps
    end
  end

  def self.down
    drop_table :exam_schedules
  end
end
